Dashboard 01 - Creating Cards and Slicer 15

In this step, we will create cards in this first dashboard.


Step 1:  Create District Name Card

In Power BI Desktop, click on the page, RaleighPoliceIncidents

Click inside the pane

Visualizations

Click the Card icon

Fields

Select the following:

A_KeyMeasures ->  .Measure_District


Visualizations

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the card to District Name 

Under Format ->  General: X Position = 983  , Y Position = 108 , Width = 417 , Height = 36

Under Format ->  Data Label ->  Color = 094780 , Text Size = 20 pt , Font = DIN (default)

Under Format -> Category ->  Set it to OFF

Under Format -> Title ->  Set it to OFF

Under Format ->  Background ->  Set it to ON , Color = CCCCCC






Step 2:  Create Violent Crime Rate Card

Click inside the pane

Visualizations

Click the Card icon

Fields

Select the following:

A_KeyMeasures ->  .Transparent_Violent_CrimeRate%


Visualizations

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the card to Violent Crime Rate 

Under Format ->  General: X Position = 1 , Y Position = 176, Width = 225 , Height = 160

Under Format ->  Data Label ->  Color = 000000 , Text Size = 28 pt , Font = DIN (default)

Under Format -> Category ->  Set it to ON ->  Color = 000000 , Text Size = 15 pt , Font = Segoe UI

Under Format -> Title ->  Set it to OFF

Under Format ->  Background ->  Set it to ON , Color = E6E6E6

Under Format ->  Border ->  Set it to ON , Color = 666666



Step 3:  Create Major Crime Rate Card

Click inside the pane

Visualizations

Click the Card icon

Fields

Select the following:

A_KeyMeasures ->  .Transparent_Major_CrimeRate%


Visualizations

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the card to Major Crime Rate 

Under Format ->  General: X Position = 1 , Y Position = 587, Width = 225 , Height = 160

Under Format ->  Data Label ->  Color = 000000 , Text Size = 28 pt , Font = DIN (default)

Under Format -> Category ->  Set it to ON ->  Color = 000000 , Text Size = 15 pt , Font = Segoe UI

Under Format -> Title ->  Set it to OFF

Under Format ->  Background ->  Set it to ON , Color = E6E6E6

Under Format ->  Border ->  Set it to ON , Color = 666666


Alternatively, copy and paste the Violent Crime Rate Card, rename it and format the position.  As follows:

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the card to Major Crime Rate 

Under Format ->  General: X Position = 1 , Y Position = 587, Width = 225 , Height = 160





Step 4:  Create Year Over Year (YOY) Violent Crime Rate Card


To get started, Copy and Paste Violent Crime Rate Card and configure it as follows:


Visualizations

Click the Card icon

Fields

Select the following:

A_KeyMeasures ->  .Transparent_Violent_Crimes_YOY%


Visualizations

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the card to YOY Violent Crime Rate 

Under Format ->  General: X Position = 1 , Y Position = 368 , Width = 225 , Height = 160

Under Format ->  Data Label ->  click fx ->  Format by = Color Scale, Based on Field = .YOY_Violent_CrimeRate% , Minimum = 5B8F22  with a value of 0.00001 , Maximum =   FF0000 with a value of 0 , Text Size = 28 pt , Font = DIN (default)

Under Format -> Category ->  Set it to ON ->  Color = 000000 , Text Size = 15 pt , Font = Segoe UI

Under Format -> Title ->  Set it to OFF

Under Format ->  Background ->  Set it to ON , Color = E6E6E6

Under Format ->  Border ->  Set it to ON , Color = 666666





Step 5:  Create Year Over Year (YOY) Major Crime Rate Card


To get started, Copy and Paste the Year Over Year (YOY) Violent Crime Rate Card and configure it as follows:


Visualizations

Click the Card icon

Fields

Select the following:

A_KeyMeasures ->  .Transparent_Major_Crimes_YOY%


Visualizations

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the card to YOY Major Crime Rate 

Under Format ->  General: X Position = 1 , Y Position = 791 , Width = 225 , Height = 160

Under Format ->  Data Label ->  click fx ->  Format by = Color Scale, Based on Field = .YOY_Major_CrimeRate% , Minimum = 5B8F22  with a value of 0.00001 , Maximum =   FF0000 with a value of 0 , Text Size = 28 pt , Font = DIN (default)

Under Format -> Category ->  Set it to ON ->  Color = 000000 , Text Size = 15 pt , Font = Segoe UI

Under Format -> Title ->  Set it to OFF

Under Format ->  Background ->  Set it to ON , Color = E6E6E6

Under Format ->  Border ->  Set it to ON , Color = 666666






Step 6:  Create Year Slicer


Visualizations

Click the Slicer icon

Fields

Select the following:

Raleigh_Police_Incidents_NIBRS ->  Reported_Date ->  Date Hierarchy ->  Year


Visualizations

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the card to YOY Major Crime Rate 

Under Format ->  General: X Position = 983  , Y Position = 0 , Width = 250 , Height = 108

Under Format ->  Numeric Inputs ->  Font Color = 000000, Text Size = 13 pt , Font = Segoe UI

Under Format -> Slider ->  Set it to ON ->  Color = 094780

Under Format -> Title ->  Set it to ON , Title Text = Years, Font Color = 094780 , Background Color = E6E6E6 , Alignment = Center , Text Size = 17 pt , Font Family = DIN (Default)

Under Format ->  Background ->  Set it to ON , Color = FFF

Under Format ->  Border ->  Set it to ON , Color = 666666






Step 7 - Create a blank Text box

Click Insert -> Text Box


Visualizations

Under Format ->  General: X Position = 384  , Y Position = 108 , Width = 599 , Height = 36

Under Format ->  Background ->  Set it to ON , Color = CCCCCC

All other visualizations settings are set to OFF.




When finished, save the project.





How to create a Card visualization in Power BI


How to create a Slicer visualization in Power BI